Building Logical DVR Model of a Multidimensional Database
نویسندگان
چکیده
Warehouse Database is a multidimensional model generally implemented in relational databases that contains a data repository. This data repository integrates valuable information from multiple data sources. This paper presents a procedure to generate the Dimension, Variable, and Relative dimension (DVR) of multidimensional cubes used in the Multidimensional On-Line Analytical Processing (MOLAP) concept. This proposed procedure uses the data mining approach to build an MDDB data model. The procedure consists of classification, partitioning, and clustering modules. Classification modules verify an attribute of data entity as a candidate dimension or a variable of multidimensional cubes. Partitioning modules use candidate dimensions as bases for mapping with other attributes of the same data entity to form mapping data sets. This module uses the Internal Comparison Process (ICP) to manipulate data sets to validate the DVR model. Finally, the clustering module uses External Comparison Process (ECP) to manipulate all DVR models in the partitioning modules in order to group the related dimensions and associated data values.
منابع مشابه
A Logical Framework for Querying
We address the issue of designing e ective query languages for OLAP databases. The basis of our investigation is MD, a logical data model for multidimensional databases that, unlike other multidimensional models, is independent of any speci c implementation. As such, MD provides a clear separation between practical and conceptual aspects of multidimensional analysis. In this framework, we prese...
متن کاملA Logical Framework for QueryingMultidimensional Data
We address the issue of designing eeective query languages for OLAP databases. The basis of our investigation is MD, a logical data model for multidimensional databases that, unlike other multidimensional models, is independent of any speciic implementation. As such, MD provides a clear separation between practical and conceptual aspects of multidimen-sional analysis. In this framework, we pres...
متن کاملA Logical Approach to Multidimensional Databases
In this paper we present MD, a logical model for OLAP systems, and show how it can be used in the design of multidimensional databases. Unlike other models for multidimensional databases, MD is independent of any speci c implementation (relational or proprietary multidimensional) and as such it provides a clear separation between practical and conceptual aspects. In this framework, we present a...
متن کاملQuerying Multidimensional Data
A powerful, easy-to-use querying environment is without doubt one of the most important components in a multidimensional database. Its effectiveness is influenced by many aspects, both logical (data model, integration, policy of view materialization, etc.) and physical (multidimensional or relational storage, indexes, etc.). Multidimensional querying is often based on the core concepts of multi...
متن کاملQuerying fuzzy summaries of databases: unary operators and their properties
In this paper we propose a general framework to explore and analyse database summaries built from massive data sets. Summaries are multidimensional vague concepts, represented by a set of fuzzy terms provided on each attribute as domain knowledge. We define a logical data model called summary partition, as cubes do in OLAP systems. We then propose a set of unary operators over this data model. ...
متن کامل